﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="InventoryStoreDataSet" targetNamespace="http://tempuri.org/InventoryStoreDataSet.xsd" xmlns:mstns="http://tempuri.org/InventoryStoreDataSet.xsd" xmlns="http://tempuri.org/InventoryStoreDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="InventoryStoreConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="InventoryStoreConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WhistlingPalms.Properties.Settings.GlobalReference.Default.InventoryStoreConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblClientTableAdapter" GeneratorDataComponentClassName="tblClientTableAdapter" Name="tblClient" UserDataComponentName="tblClientTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblClient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblClient] WHERE (([ClientID] = @Original_ClientID) AND ([ClientName] = @Original_ClientName) AND ((@IsNull_ContactNo = 1 AND [ContactNo] IS NULL) OR ([ContactNo] = @Original_ContactNo)) AND ((@IsNull_ContactPerson = 1 AND [ContactPerson] IS NULL) OR ([ContactPerson] = @Original_ContactPerson)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_EmailID = 1 AND [EmailID] IS NULL) OR ([EmailID] = @Original_EmailID)) AND ([IsVendor] = @Original_IsVendor) AND ([IsCustomer] = @Original_IsCustomer))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ClientName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactPerson" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactPerson" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContactPerson" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsVendor" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsVendor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsCustomer" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsCustomer" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblClient] ([ClientName], [ContactNo], [ContactPerson], [Address], [EmailID], [IsVendor], [IsCustomer]) VALUES (@ClientName, @ContactNo, @ContactPerson, @Address, @EmailID, @IsVendor, @IsCustomer);
SELECT ClientID, ClientName, ContactNo, ContactPerson, Address, EmailID, IsVendor, IsCustomer FROM tblClient WHERE (ClientID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ClientName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContactPerson" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsVendor" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsVendor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsCustomer" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsCustomer" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ClientID, ClientName, ContactNo, ContactPerson, Address, EmailID, IsVendor, IsCustomer FROM dbo.tblClient</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblClient] SET [ClientName] = @ClientName, [ContactNo] = @ContactNo, [ContactPerson] = @ContactPerson, [Address] = @Address, [EmailID] = @EmailID, [IsVendor] = @IsVendor, [IsCustomer] = @IsCustomer WHERE (([ClientID] = @Original_ClientID) AND ([ClientName] = @Original_ClientName) AND ((@IsNull_ContactNo = 1 AND [ContactNo] IS NULL) OR ([ContactNo] = @Original_ContactNo)) AND ((@IsNull_ContactPerson = 1 AND [ContactPerson] IS NULL) OR ([ContactPerson] = @Original_ContactPerson)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_EmailID = 1 AND [EmailID] IS NULL) OR ([EmailID] = @Original_EmailID)) AND ([IsVendor] = @Original_IsVendor) AND ([IsCustomer] = @Original_IsCustomer));
SELECT ClientID, ClientName, ContactNo, ContactPerson, Address, EmailID, IsVendor, IsCustomer FROM tblClient WHERE (ClientID = @ClientID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ClientName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ContactPerson" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsVendor" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsVendor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsCustomer" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsCustomer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ClientName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactPerson" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactPerson" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ContactPerson" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsVendor" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsVendor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsCustomer" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsCustomer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ClientID" ColumnName="ClientID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblClient" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ClientID" DataSetColumn="ClientID" />
              <Mapping SourceColumn="ClientName" DataSetColumn="ClientName" />
              <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
              <Mapping SourceColumn="ContactPerson" DataSetColumn="ContactPerson" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="EmailID" DataSetColumn="EmailID" />
              <Mapping SourceColumn="IsVendor" DataSetColumn="IsVendor" />
              <Mapping SourceColumn="IsCustomer" DataSetColumn="IsCustomer" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblClient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillClientByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetClientByID" GeneratorSourceName="FillClientByID" GetMethodModifier="Public" GetMethodName="GetClientByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetClientByID" UserSourceName="FillClientByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ClientID, ClientName, ContactNo, ContactPerson, Address, EmailID, IsVendor, IsCustomer
FROM            tblClient
WHERE        (ClientID = @ClientID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ClientID" ColumnName="ClientID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblClient" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblClient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCustomers" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCustomers" GeneratorSourceName="FillCustomers" GetMethodModifier="Public" GetMethodName="GetCustomers" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCustomers" UserSourceName="FillCustomers">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ClientID, ClientName, ContactNo, ContactPerson, Address, EmailID, IsVendor, IsCustomer
FROM            tblClient
WHERE        (IsCustomer = 1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblClient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillVendors" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetVendors" GeneratorSourceName="FillVendors" GetMethodModifier="Public" GetMethodName="GetVendors" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetVendors" UserSourceName="FillVendors">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ClientID, ClientName, ContactNo, ContactPerson, Address, EmailID, IsVendor, IsCustomer
FROM            tblClient
WHERE        (IsVendor = 1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblInventoryTableAdapter" GeneratorDataComponentClassName="tblInventoryTableAdapter" Name="tblInventory" UserDataComponentName="tblInventoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblInventory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblInventory] WHERE (([InventoryID] = @Original_InventoryID) AND ([ProductID] = @Original_ProductID) AND ([WareHouseID] = @Original_WareHouseID) AND ([Cost] = @Original_Cost) AND ([Quantity] = @Original_Quantity))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InventoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InventoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Quantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblInventory] ([ProductID], [WareHouseID], [Cost], [Quantity]) VALUES (@ProductID, @WareHouseID, @Cost, @Quantity);
SELECT InventoryID, ProductID, WareHouseID, Cost, Quantity FROM tblInventory WHERE (InventoryID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Quantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT InventoryID, ProductID, WareHouseID, Cost, Quantity FROM dbo.tblInventory</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblInventory] SET [ProductID] = @ProductID, [WareHouseID] = @WareHouseID, [Cost] = @Cost, [Quantity] = @Quantity WHERE (([InventoryID] = @Original_InventoryID) AND ([ProductID] = @Original_ProductID) AND ([WareHouseID] = @Original_WareHouseID) AND ([Cost] = @Original_Cost) AND ([Quantity] = @Original_Quantity));
SELECT InventoryID, ProductID, WareHouseID, Cost, Quantity FROM tblInventory WHERE (InventoryID = @InventoryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Quantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InventoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InventoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Quantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="InventoryID" ColumnName="InventoryID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@InventoryID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="InventoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="InventoryID" DataSetColumn="InventoryID" />
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="WareHouseID" DataSetColumn="WareHouseID" />
              <Mapping SourceColumn="Cost" DataSetColumn="Cost" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteInventoryEntry" Modifier="Public" Name="DeleteInventoryEntry" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteInventoryEntry">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM tblInventory
WHERE        (ProductID = @ProductID) AND (WareHouseID = @WareHouseID) AND (Cost = @Cost)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductID" ColumnName="ProductID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="WareHouseID" ColumnName="WareHouseID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Cost" ColumnName="Cost" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblInventory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProductAndWareHouse" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProductAndWareHouse" GeneratorSourceName="FillByProductAndWareHouse" GetMethodModifier="Public" GetMethodName="GetDataByProductAndWareHouse" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProductAndWareHouse" UserSourceName="FillByProductAndWareHouse">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        InventoryID, ProductID, WareHouseID, Cost, Quantity
FROM            tblInventory
WHERE        (ProductID = @ProductID) AND (WareHouseID = @WareHouseID)
ORDER BY Cost</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductID" ColumnName="ProductID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="WareHouseID" ColumnName="WareHouseID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetQuantity" Modifier="Public" Name="GetQuantity" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetQuantity">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ISNULL(SUM(Quantity), 0) AS TotalQuantity
FROM            tblInventory
WHERE        (ProductID = @ProductID) AND (WareHouseID = @WareHouseID) AND (@Cost IS NULL OR
                         Cost = @Cost)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductID" ColumnName="ProductID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="WareHouseID" ColumnName="WareHouseID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Cost" ColumnName="Cost" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="0" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuantity" Modifier="Public" Name="UpdateQuantity" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuantity">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       tblInventory
SET                Quantity = @Quantity
WHERE        (ProductID = @ProductID) AND (WareHouseID = @WareHouseID) AND (Cost = @Cost)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Quantity" ColumnName="Quantity" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Quantity" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductID" ColumnName="ProductID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="WareHouseID" ColumnName="WareHouseID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Cost" ColumnName="Cost" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblInventory" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblProductsTableAdapter" GeneratorDataComponentClassName="tblProductsTableAdapter" Name="tblProducts" UserDataComponentName="tblProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblProducts" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblProducts] WHERE (([ProductID] = @Original_ProductID) AND ([ProductName] = @Original_ProductName) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_Manufacturer = 1 AND [Manufacturer] IS NULL) OR ([Manufacturer] = @Original_Manufacturer)) AND ((@IsNull_ProductTag1 = 1 AND [ProductTag1] IS NULL) OR ([ProductTag1] = @Original_ProductTag1)) AND ((@IsNull_ProductTag2 = 1 AND [ProductTag2] IS NULL) OR ([ProductTag2] = @Original_ProductTag2)) AND ((@IsNull_SalePrice = 1 AND [SalePrice] IS NULL) OR ([SalePrice] = @Original_SalePrice)) AND ([Discontinued] = @Original_Discontinued))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Manufacturer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Manufacturer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductTag1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductTag1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ProductTag1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductTag1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductTag2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductTag2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ProductTag2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductTag2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SalePrice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalePrice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SalePrice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="SalePrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Discontinued" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Discontinued" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblProducts] ([ProductName], [Description], [Manufacturer], [ProductTag1], [ProductTag2], [SalePrice], [Discontinued]) VALUES (@ProductName, @Description, @Manufacturer, @ProductTag1, @ProductTag2, @SalePrice, @Discontinued);
SELECT ProductID, ProductName, Description, Manufacturer, ProductTag1, ProductTag2, SalePrice, Discontinued FROM tblProducts WHERE (ProductID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Manufacturer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductTag1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductTag1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductTag2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductTag2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SalePrice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="SalePrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Discontinued" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Discontinued" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ProductID, ProductName, Description, Manufacturer, ProductTag1, ProductTag2, SalePrice, Discontinued FROM dbo.tblProducts</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblProducts] SET [ProductName] = @ProductName, [Description] = @Description, [Manufacturer] = @Manufacturer, [ProductTag1] = @ProductTag1, [ProductTag2] = @ProductTag2, [SalePrice] = @SalePrice, [Discontinued] = @Discontinued WHERE (([ProductID] = @Original_ProductID) AND ([ProductName] = @Original_ProductName) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_Manufacturer = 1 AND [Manufacturer] IS NULL) OR ([Manufacturer] = @Original_Manufacturer)) AND ((@IsNull_ProductTag1 = 1 AND [ProductTag1] IS NULL) OR ([ProductTag1] = @Original_ProductTag1)) AND ((@IsNull_ProductTag2 = 1 AND [ProductTag2] IS NULL) OR ([ProductTag2] = @Original_ProductTag2)) AND ((@IsNull_SalePrice = 1 AND [SalePrice] IS NULL) OR ([SalePrice] = @Original_SalePrice)) AND ([Discontinued] = @Original_Discontinued));
SELECT ProductID, ProductName, Description, Manufacturer, ProductTag1, ProductTag2, SalePrice, Discontinued FROM tblProducts WHERE (ProductID = @ProductID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Manufacturer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductTag1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductTag1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductTag2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductTag2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SalePrice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="SalePrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Discontinued" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Discontinued" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Manufacturer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Manufacturer" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Manufacturer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductTag1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductTag1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ProductTag1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductTag1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductTag2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductTag2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ProductTag2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductTag2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SalePrice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalePrice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SalePrice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="SalePrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Discontinued" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Discontinued" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductID" ColumnName="ProductID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblProducts" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Manufacturer" DataSetColumn="Manufacturer" />
              <Mapping SourceColumn="ProductTag1" DataSetColumn="ProductTag1" />
              <Mapping SourceColumn="ProductTag2" DataSetColumn="ProductTag2" />
              <Mapping SourceColumn="SalePrice" DataSetColumn="SalePrice" />
              <Mapping SourceColumn="Discontinued" DataSetColumn="Discontinued" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblProducts" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillActiveProducts" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetActiveProducts" GeneratorSourceName="FillActiveProducts" GetMethodModifier="Public" GetMethodName="GetActiveProducts" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetActiveProducts" UserSourceName="FillActiveProducts">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ProductID, ProductName, Description, Manufacturer, ProductTag1, ProductTag2, SalePrice, Discontinued
FROM            tblProducts
WHERE        (Discontinued = 0)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblProducts" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillProductByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetProductByID" GeneratorSourceName="FillProductByID" GetMethodModifier="Public" GetMethodName="GetProductByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetProductByID" UserSourceName="FillProductByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ProductID, ProductName, Description, Manufacturer, ProductTag1, ProductTag2, SalePrice, Discontinued
FROM            tblProducts
WHERE        (ProductID = @ProductID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductID" ColumnName="ProductID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblProducts" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblTransactionTableAdapter" GeneratorDataComponentClassName="tblTransactionTableAdapter" Name="tblTransaction" UserDataComponentName="tblTransactionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblTransaction" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblTransaction] WHERE (([TransactionID] = @Original_TransactionID) AND ([TransactionDetails] = @Original_TransactionDetails) AND ([TransactionDate] = @Original_TransactionDate) AND ([TransactionTypeID] = @Original_TransactionTypeID) AND ((@IsNull_OrderNo = 1 AND [OrderNo] IS NULL) OR ([OrderNo] = @Original_OrderNo)) AND ((@IsNull_ClientID = 1 AND [ClientID] IS NULL) OR ([ClientID] = @Original_ClientID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TransactionDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransactionDetails" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TransactionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransactionDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OrderNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OrderNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblTransaction] ([TransactionDetails], [TransactionDate], [TransactionTypeID], [Remarks], [OrderNo], [ClientID]) VALUES (@TransactionDetails, @TransactionDate, @TransactionTypeID, @Remarks, @OrderNo, @ClientID);
SELECT TransactionID, TransactionDetails, TransactionDate, TransactionTypeID, Remarks, OrderNo, ClientID FROM tblTransaction WHERE (TransactionID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TransactionDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransactionDetails" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TransactionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransactionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TransactionTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OrderNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OrderNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TransactionID, TransactionDetails, TransactionDate, TransactionTypeID, Remarks, OrderNo, ClientID
FROM            tblTransaction</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblTransaction] SET [TransactionDetails] = @TransactionDetails, [TransactionDate] = @TransactionDate, [TransactionTypeID] = @TransactionTypeID, [Remarks] = @Remarks, [OrderNo] = @OrderNo, [ClientID] = @ClientID WHERE (([TransactionID] = @Original_TransactionID) AND ([TransactionDetails] = @Original_TransactionDetails) AND ([TransactionDate] = @Original_TransactionDate) AND ([TransactionTypeID] = @Original_TransactionTypeID) AND ((@IsNull_OrderNo = 1 AND [OrderNo] IS NULL) OR ([OrderNo] = @Original_OrderNo)) AND ((@IsNull_ClientID = 1 AND [ClientID] IS NULL) OR ([ClientID] = @Original_ClientID)));
SELECT TransactionID, TransactionDetails, TransactionDate, TransactionTypeID, Remarks, OrderNo, ClientID FROM tblTransaction WHERE (TransactionID = @TransactionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TransactionDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransactionDetails" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TransactionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransactionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TransactionTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OrderNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OrderNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TransactionDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransactionDetails" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TransactionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransactionDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OrderNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OrderNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactionID" ColumnName="TransactionID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransaction" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TransactionID" DataSetColumn="TransactionID" />
              <Mapping SourceColumn="TransactionDetails" DataSetColumn="TransactionDetails" />
              <Mapping SourceColumn="TransactionDate" DataSetColumn="TransactionDate" />
              <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
              <Mapping SourceColumn="OrderNo" DataSetColumn="OrderNo" />
              <Mapping SourceColumn="ClientID" DataSetColumn="ClientID" />
              <Mapping SourceColumn="TransactionTypeID" DataSetColumn="TransactionTypeID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertTransaction" Modifier="Public" Name="InsertTransaction" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertTransaction">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [tblTransaction] ([TransactionDetails], [TransactionDate], [TransactionTypeID], [Remarks], [OrderNo], [ClientID]) VALUES (@TransactionDetails, @TransactionDate, @TransactionTypeID, @Remarks, @OrderNo, @ClientID);
SELECT SCOPE_IDENTITY()</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactionDetails" ColumnName="TransactionDetails" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransaction" DataTypeServer="varchar(1000)" DbType="AnsiString" Direction="Input" ParameterName="@TransactionDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="1000" SourceColumn="TransactionDetails" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactionDate" ColumnName="TransactionDate" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransaction" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@TransactionDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="TransactionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactionTypeID" ColumnName="TransactionTypeID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransaction" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TransactionTypeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TransactionTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Remarks" ColumnName="Remarks" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransaction" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@Remarks" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="Remarks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="OrderNo" ColumnName="OrderNo" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransaction" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@OrderNo" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="OrderNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ClientID" ColumnName="ClientID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransaction" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ClientID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblWareHouseTableAdapter" GeneratorDataComponentClassName="tblWareHouseTableAdapter" Name="tblWareHouse" UserDataComponentName="tblWareHouseTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblWareHouse" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblWareHouse] WHERE (([WareHouseID] = @Original_WareHouseID) AND ([WareHouseName] = @Original_WareHouseName) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_TelephoneNo = 1 AND [TelephoneNo] IS NULL) OR ([TelephoneNo] = @Original_TelephoneNo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_WareHouseName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WareHouseName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelephoneNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelephoneNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelephoneNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelephoneNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblWareHouse] ([WareHouseName], [Description], [Address], [TelephoneNo]) VALUES (@WareHouseName, @Description, @Address, @TelephoneNo);
SELECT WareHouseID, WareHouseName, Description, Address, TelephoneNo FROM tblWareHouse WHERE (WareHouseID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WareHouseName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WareHouseName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelephoneNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelephoneNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT WareHouseID, WareHouseName, Description, Address, TelephoneNo FROM dbo.tblWareHouse</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblWareHouse] SET [WareHouseName] = @WareHouseName, [Description] = @Description, [Address] = @Address, [TelephoneNo] = @TelephoneNo WHERE (([WareHouseID] = @Original_WareHouseID) AND ([WareHouseName] = @Original_WareHouseName) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_TelephoneNo = 1 AND [TelephoneNo] IS NULL) OR ([TelephoneNo] = @Original_TelephoneNo)));
SELECT WareHouseID, WareHouseName, Description, Address, TelephoneNo FROM tblWareHouse WHERE (WareHouseID = @WareHouseID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WareHouseName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WareHouseName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelephoneNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelephoneNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_WareHouseName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WareHouseName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelephoneNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelephoneNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelephoneNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelephoneNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="WareHouseID" ColumnName="WareHouseID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblWareHouse" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@WareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="WareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WareHouseID" DataSetColumn="WareHouseID" />
              <Mapping SourceColumn="WareHouseName" DataSetColumn="WareHouseName" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="TelephoneNo" DataSetColumn="TelephoneNo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InventoryDetailsTableAdapter" GeneratorDataComponentClassName="InventoryDetailsTableAdapter" Name="InventoryDetails" UserDataComponentName="InventoryDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblProducts.ProductID, tblProducts.ProductName, tblProducts.Manufacturer, tblWareHouse.WareHouseID, tblWareHouse.WareHouseName, tblInventory.Cost, 
                         tblInventory.Quantity
FROM            tblInventory INNER JOIN
                         tblProducts ON tblInventory.ProductID = tblProducts.ProductID INNER JOIN
                         tblWareHouse ON tblInventory.WareHouseID = tblWareHouse.WareHouseID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="Manufacturer" DataSetColumn="Manufacturer" />
              <Mapping SourceColumn="WareHouseID" DataSetColumn="WareHouseID" />
              <Mapping SourceColumn="WareHouseName" DataSetColumn="WareHouseName" />
              <Mapping SourceColumn="Cost" DataSetColumn="Cost" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblTransactionTypeTableAdapter" GeneratorDataComponentClassName="tblTransactionTypeTableAdapter" Name="tblTransactionType" UserDataComponentName="tblTransactionTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblTransactionType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblTransactionType] WHERE (([TransactionTypeID] = @Original_TransactionTypeID) AND ([TransactionType] = @Original_TransactionType) AND ([ActionType] = @Original_ActionType) AND ([HasClientOrderInformation] = @Original_HasClientOrderInformation))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TransactionType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransactionType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ActionType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ActionType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_HasClientOrderInformation" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasClientOrderInformation" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblTransactionType] ([TransactionType], [ActionType], [HasClientOrderInformation]) VALUES (@TransactionType, @ActionType, @HasClientOrderInformation);
SELECT TransactionTypeID, TransactionType, ActionType, HasClientOrderInformation FROM tblTransactionType WHERE (TransactionTypeID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TransactionType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransactionType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ActionType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ActionType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@HasClientOrderInformation" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasClientOrderInformation" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TransactionTypeID, TransactionType, ActionType, HasClientOrderInformation
FROM            tblTransactionType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblTransactionType] SET [TransactionType] = @TransactionType, [ActionType] = @ActionType, [HasClientOrderInformation] = @HasClientOrderInformation WHERE (([TransactionTypeID] = @Original_TransactionTypeID) AND ([TransactionType] = @Original_TransactionType) AND ([ActionType] = @Original_ActionType) AND ([HasClientOrderInformation] = @Original_HasClientOrderInformation));
SELECT TransactionTypeID, TransactionType, ActionType, HasClientOrderInformation FROM tblTransactionType WHERE (TransactionTypeID = @TransactionTypeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TransactionType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransactionType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ActionType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ActionType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@HasClientOrderInformation" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasClientOrderInformation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TransactionType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TransactionType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ActionType" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ActionType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_HasClientOrderInformation" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasClientOrderInformation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactionTypeID" ColumnName="TransactionTypeID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionType" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TransactionTypeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TransactionTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TransactionTypeID" DataSetColumn="TransactionTypeID" />
              <Mapping SourceColumn="TransactionType" DataSetColumn="TransactionType" />
              <Mapping SourceColumn="ActionType" DataSetColumn="ActionType" />
              <Mapping SourceColumn="HasClientOrderInformation" DataSetColumn="HasClientOrderInformation" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblTransactionType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillDataByTransactionTypeID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTransactionTypeID" GeneratorSourceName="FillDataByTransactionTypeID" GetMethodModifier="Public" GetMethodName="GetDataByTransactionTypeID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTransactionTypeID" UserSourceName="FillDataByTransactionTypeID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TransactionTypeID, TransactionType, ActionType, HasClientOrderInformation
FROM            tblTransactionType
WHERE        (TransactionTypeID = @TransactionTypeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactionTypeID" ColumnName="TransactionTypeID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionType" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TransactionTypeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TransactionTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientTransactionsTableAdapter" GeneratorDataComponentClassName="ClientTransactionsTableAdapter" Name="ClientTransactions" UserDataComponentName="ClientTransactionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblTransaction.TransactionID, tblTransaction.TransactionDetails, tblTransaction.TransactionDate, tblTransaction.TransactionTypeID, 
                         tblTransactionType.TransactionType, tblTransactionType.ActionType, tblTransactionType.HasClientOrderInformation, tblTransaction.Remarks, 
                         tblTransaction.OrderNo, tblTransaction.ClientID, tblClient.ClientName
FROM            tblTransaction INNER JOIN
                         tblClient ON tblTransaction.ClientID = tblClient.ClientID INNER JOIN
                         tblTransactionType ON tblTransaction.TransactionTypeID = tblTransactionType.TransactionTypeID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TransactionID" DataSetColumn="TransactionID" />
              <Mapping SourceColumn="TransactionDetails" DataSetColumn="TransactionDetails" />
              <Mapping SourceColumn="TransactionDate" DataSetColumn="TransactionDate" />
              <Mapping SourceColumn="TransactionTypeID" DataSetColumn="TransactionTypeID" />
              <Mapping SourceColumn="TransactionType" DataSetColumn="TransactionType" />
              <Mapping SourceColumn="ActionType" DataSetColumn="ActionType" />
              <Mapping SourceColumn="HasClientOrderInformation" DataSetColumn="HasClientOrderInformation" />
              <Mapping SourceColumn="Remarks" DataSetColumn="Remarks" />
              <Mapping SourceColumn="OrderNo" DataSetColumn="OrderNo" />
              <Mapping SourceColumn="ClientID" DataSetColumn="ClientID" />
              <Mapping SourceColumn="ClientName" DataSetColumn="ClientName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblTransactionDetailsTableAdapter" GeneratorDataComponentClassName="tblTransactionDetailsTableAdapter" Name="tblTransactionDetails" UserDataComponentName="tblTransactionDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblTransactionDetails" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblTransactionDetails] WHERE (([TransactionDetailID] = @Original_TransactionDetailID) AND ([TransactionID] = @Original_TransactionID) AND ([ProductID] = @Original_ProductID) AND ([FromWareHouseID] = @Original_FromWareHouseID) AND ((@IsNull_ToWareHouseID = 1 AND [ToWareHouseID] IS NULL) OR ([ToWareHouseID] = @Original_ToWareHouseID)) AND ([TransactQuantity] = @Original_TransactQuantity) AND ((@IsNull_TransactCost = 1 AND [TransactCost] IS NULL) OR ([TransactCost] = @Original_TransactCost)) AND ((@IsNull_TotalCost = 1 AND [TotalCost] IS NULL) OR ([TotalCost] = @Original_TotalCost)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionDetailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionDetailID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FromWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FromWareHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ToWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ToWareHouseID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ToWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ToWareHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TransactQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TransactQuantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TransactCost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TransactCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalCost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TotalCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[tblTransactionDetails] ([TransactionID], [ProductID], [FromWareHouseID], [ToWareHouseID], [TransactQuantity], [TransactCost], [TotalCost]) VALUES (@TransactionID, @ProductID, @FromWareHouseID, @ToWareHouseID, @TransactQuantity, @TransactCost, @TotalCost);
SELECT SCOPE_IDENTITY();</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactionID" ColumnName="TransactionID" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductID" ColumnName="ProductID" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="FromWareHouseID" ColumnName="FromWareHouseID" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@FromWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FromWareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ToWareHouseID" ColumnName="ToWareHouseID" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ToWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ToWareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactQuantity" ColumnName="TransactQuantity" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@TransactQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="TransactQuantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TransactCost" ColumnName="TransactCost" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@TransactCost" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="TransactCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TotalCost" ColumnName="TotalCost" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@TotalCost" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="TotalCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT TransactionDetailID, TransactionID, ProductID, FromWareHouseID, ToWareHouseID, TransactQuantity, TransactCost, TotalCost FROM dbo.tblTransactionDetails</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblTransactionDetails] SET [TransactionID] = @TransactionID, [ProductID] = @ProductID, [FromWareHouseID] = @FromWareHouseID, [ToWareHouseID] = @ToWareHouseID, [TransactQuantity] = @TransactQuantity, [TransactCost] = @TransactCost, [TotalCost] = @TotalCost WHERE (([TransactionDetailID] = @Original_TransactionDetailID) AND ([TransactionID] = @Original_TransactionID) AND ([ProductID] = @Original_ProductID) AND ([FromWareHouseID] = @Original_FromWareHouseID) AND ((@IsNull_ToWareHouseID = 1 AND [ToWareHouseID] IS NULL) OR ([ToWareHouseID] = @Original_ToWareHouseID)) AND ([TransactQuantity] = @Original_TransactQuantity) AND ((@IsNull_TransactCost = 1 AND [TransactCost] IS NULL) OR ([TransactCost] = @Original_TransactCost)) AND ((@IsNull_TotalCost = 1 AND [TotalCost] IS NULL) OR ([TotalCost] = @Original_TotalCost)));
SELECT TransactionDetailID, TransactionID, ProductID, FromWareHouseID, ToWareHouseID, TransactQuantity, TransactCost, TotalCost FROM tblTransactionDetails WHERE (TransactionDetailID = @TransactionDetailID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FromWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FromWareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ToWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ToWareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TransactQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TransactQuantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TransactCost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TransactCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TotalCost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TotalCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionDetailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionDetailID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FromWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FromWareHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ToWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ToWareHouseID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ToWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ToWareHouseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TransactQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TransactQuantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransactCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TransactCost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TransactCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TotalCost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="TotalCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactionDetailID" ColumnName="TransactionDetailID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TransactionDetailID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TransactionDetailID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TransactionDetailID" DataSetColumn="TransactionDetailID" />
              <Mapping SourceColumn="TransactionID" DataSetColumn="TransactionID" />
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="FromWareHouseID" DataSetColumn="FromWareHouseID" />
              <Mapping SourceColumn="ToWareHouseID" DataSetColumn="ToWareHouseID" />
              <Mapping SourceColumn="TransactQuantity" DataSetColumn="TransactQuantity" />
              <Mapping SourceColumn="TransactCost" DataSetColumn="TransactCost" />
              <Mapping SourceColumn="TotalCost" DataSetColumn="TotalCost" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertTransactionDetails" Modifier="Public" Name="InsertTransactionDetails" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertTransactionDetails">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[tblTransactionDetails] ([TransactionID], [ProductID], [FromWareHouseID], [ToWareHouseID], [TransactQuantity], [TransactCost], [TotalCost]) VALUES (@TransactionID, @ProductID, @FromWareHouseID, @ToWareHouseID, @TransactQuantity, @TransactCost, @TotalCost);
SELECT SCOPE_IDENTITY();</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactionID" ColumnName="TransactionID" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TransactionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TransactionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ProductID" ColumnName="ProductID" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="FromWareHouseID" ColumnName="FromWareHouseID" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@FromWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="FromWareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ToWareHouseID" ColumnName="ToWareHouseID" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ToWareHouseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ToWareHouseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactQuantity" ColumnName="TransactQuantity" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@TransactQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="TransactQuantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TransactCost" ColumnName="TransactCost" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@TransactCost" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="TransactCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TotalCost" ColumnName="TotalCost" DataSourceName="[D:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionDetails" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@TotalCost" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="TotalCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblTransactionStockInformationTableAdapter" GeneratorDataComponentClassName="tblTransactionStockInformationTableAdapter" Name="tblTransactionStockInformation" UserDataComponentName="tblTransactionStockInformationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="InventoryStoreConnectionString (Settings)" DbObjectName="dbo.tblTransactionStockInformation" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblTransactionStockInformation] WHERE (([TransactionStockInformationID] = @Original_TransactionStockInformationID) AND ([TransactionDetailID] = @Original_TransactionDetailID) AND ([Cost] = @Original_Cost) AND ([OldQuantity] = @Original_OldQuantity) AND ([NewQuantity] = @Original_NewQuantity) AND ([IsFromWareHouse] = @Original_IsFromWareHouse))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionStockInformationID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionStockInformationID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionDetailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionDetailID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OldQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="OldQuantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NewQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NewQuantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsFromWareHouse" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsFromWareHouse" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblTransactionStockInformation] ([TransactionDetailID], [Cost], [OldQuantity], [NewQuantity], [IsFromWareHouse]) VALUES (@TransactionDetailID, @Cost, @OldQuantity, @NewQuantity, @IsFromWareHouse);
SELECT TransactionStockInformationID, TransactionDetailID, Cost, OldQuantity, NewQuantity, IsFromWareHouse FROM tblTransactionStockInformation WHERE (TransactionStockInformationID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TransactionDetailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionDetailID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OldQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="OldQuantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NewQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NewQuantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsFromWareHouse" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsFromWareHouse" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TransactionStockInformationID, TransactionDetailID, Cost, OldQuantity, NewQuantity, IsFromWareHouse
FROM            tblTransactionStockInformation</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblTransactionStockInformation] SET [TransactionDetailID] = @TransactionDetailID, [Cost] = @Cost, [OldQuantity] = @OldQuantity, [NewQuantity] = @NewQuantity, [IsFromWareHouse] = @IsFromWareHouse WHERE (([TransactionStockInformationID] = @Original_TransactionStockInformationID) AND ([TransactionDetailID] = @Original_TransactionDetailID) AND ([Cost] = @Original_Cost) AND ([OldQuantity] = @Original_OldQuantity) AND ([NewQuantity] = @Original_NewQuantity) AND ([IsFromWareHouse] = @Original_IsFromWareHouse));
SELECT TransactionStockInformationID, TransactionDetailID, Cost, OldQuantity, NewQuantity, IsFromWareHouse FROM tblTransactionStockInformation WHERE (TransactionStockInformationID = @TransactionStockInformationID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TransactionDetailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionDetailID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@OldQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="OldQuantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NewQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NewQuantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsFromWareHouse" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsFromWareHouse" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionStockInformationID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionStockInformationID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TransactionDetailID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransactionDetailID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cost" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_OldQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="OldQuantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NewQuantity" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NewQuantity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsFromWareHouse" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsFromWareHouse" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TransactionStockInformationID" ColumnName="TransactionStockInformationID" DataSourceName="[E:\PROJECTS\WHISTLINGPALMS\WHISTLINGPALMS\INVENTORYSTORE.MDF].dbo.tblTransactionStockInformation" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TransactionStockInformationID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TransactionStockInformationID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TransactionStockInformationID" DataSetColumn="TransactionStockInformationID" />
              <Mapping SourceColumn="TransactionDetailID" DataSetColumn="TransactionDetailID" />
              <Mapping SourceColumn="Cost" DataSetColumn="Cost" />
              <Mapping SourceColumn="OldQuantity" DataSetColumn="OldQuantity" />
              <Mapping SourceColumn="NewQuantity" DataSetColumn="NewQuantity" />
              <Mapping SourceColumn="IsFromWareHouse" DataSetColumn="IsFromWareHouse" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="InventoryStoreDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="InventoryStoreDataSet" msprop:Generator_UserDSName="InventoryStoreDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblClient" msprop:Generator_TableClassName="tblClientDataTable" msprop:Generator_TableVarName="tabletblClient" msprop:Generator_TablePropName="tblClient" msprop:Generator_RowDeletingName="tblClientRowDeleting" msprop:Generator_UserTableName="tblClient" msprop:Generator_RowChangingName="tblClientRowChanging" msprop:Generator_RowEvHandlerName="tblClientRowChangeEventHandler" msprop:Generator_RowDeletedName="tblClientRowDeleted" msprop:Generator_RowEvArgName="tblClientRowChangeEvent" msprop:Generator_RowChangedName="tblClientRowChanged" msprop:Generator_RowClassName="tblClientRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ClientID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnClientID" msprop:Generator_ColumnPropNameInRow="ClientID" msprop:Generator_ColumnPropNameInTable="ClientIDColumn" msprop:Generator_UserColumnName="ClientID" type="xs:int" />
              <xs:element name="ClientName" msprop:Generator_ColumnVarNameInTable="columnClientName" msprop:Generator_ColumnPropNameInRow="ClientName" msprop:Generator_ColumnPropNameInTable="ClientNameColumn" msprop:Generator_UserColumnName="ClientName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactPerson" msprop:Generator_ColumnVarNameInTable="columnContactPerson" msprop:Generator_ColumnPropNameInRow="ContactPerson" msprop:Generator_ColumnPropNameInTable="ContactPersonColumn" msprop:Generator_UserColumnName="ContactPerson" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmailID" msprop:Generator_ColumnVarNameInTable="columnEmailID" msprop:Generator_ColumnPropNameInRow="EmailID" msprop:Generator_ColumnPropNameInTable="EmailIDColumn" msprop:Generator_UserColumnName="EmailID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsVendor" msprop:Generator_ColumnVarNameInTable="columnIsVendor" msprop:Generator_ColumnPropNameInRow="IsVendor" msprop:Generator_ColumnPropNameInTable="IsVendorColumn" msprop:Generator_UserColumnName="IsVendor" type="xs:boolean" />
              <xs:element name="IsCustomer" msprop:Generator_ColumnVarNameInTable="columnIsCustomer" msprop:Generator_ColumnPropNameInRow="IsCustomer" msprop:Generator_ColumnPropNameInTable="IsCustomerColumn" msprop:Generator_UserColumnName="IsCustomer" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblInventory" msprop:Generator_TableClassName="tblInventoryDataTable" msprop:Generator_TableVarName="tabletblInventory" msprop:Generator_TablePropName="tblInventory" msprop:Generator_RowDeletingName="tblInventoryRowDeleting" msprop:Generator_UserTableName="tblInventory" msprop:Generator_RowChangingName="tblInventoryRowChanging" msprop:Generator_RowEvHandlerName="tblInventoryRowChangeEventHandler" msprop:Generator_RowDeletedName="tblInventoryRowDeleted" msprop:Generator_RowEvArgName="tblInventoryRowChangeEvent" msprop:Generator_RowChangedName="tblInventoryRowChanged" msprop:Generator_RowClassName="tblInventoryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="InventoryID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnInventoryID" msprop:Generator_ColumnPropNameInRow="InventoryID" msprop:Generator_ColumnPropNameInTable="InventoryIDColumn" msprop:Generator_UserColumnName="InventoryID" type="xs:int" />
              <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
              <xs:element name="WareHouseID" msprop:Generator_ColumnVarNameInTable="columnWareHouseID" msprop:Generator_ColumnPropNameInRow="WareHouseID" msprop:Generator_ColumnPropNameInTable="WareHouseIDColumn" msprop:Generator_UserColumnName="WareHouseID" type="xs:int" />
              <xs:element name="Cost" msprop:Generator_ColumnVarNameInTable="columnCost" msprop:Generator_ColumnPropNameInRow="Cost" msprop:Generator_ColumnPropNameInTable="CostColumn" msprop:Generator_UserColumnName="Cost" type="xs:decimal" />
              <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblProducts" msprop:Generator_TableClassName="tblProductsDataTable" msprop:Generator_TableVarName="tabletblProducts" msprop:Generator_TablePropName="tblProducts" msprop:Generator_RowDeletingName="tblProductsRowDeleting" msprop:Generator_UserTableName="tblProducts" msprop:Generator_RowChangingName="tblProductsRowChanging" msprop:Generator_RowEvHandlerName="tblProductsRowChangeEventHandler" msprop:Generator_RowDeletedName="tblProductsRowDeleted" msprop:Generator_RowEvArgName="tblProductsRowChangeEvent" msprop:Generator_RowChangedName="tblProductsRowChanged" msprop:Generator_RowClassName="tblProductsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProductID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
              <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Manufacturer" msprop:Generator_ColumnVarNameInTable="columnManufacturer" msprop:Generator_ColumnPropNameInRow="Manufacturer" msprop:Generator_ColumnPropNameInTable="ManufacturerColumn" msprop:Generator_UserColumnName="Manufacturer" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductTag1" msprop:Generator_ColumnVarNameInTable="columnProductTag1" msprop:Generator_ColumnPropNameInRow="ProductTag1" msprop:Generator_ColumnPropNameInTable="ProductTag1Column" msprop:Generator_UserColumnName="ProductTag1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductTag2" msprop:Generator_ColumnVarNameInTable="columnProductTag2" msprop:Generator_ColumnPropNameInRow="ProductTag2" msprop:Generator_ColumnPropNameInTable="ProductTag2Column" msprop:Generator_UserColumnName="ProductTag2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SalePrice" msprop:Generator_ColumnVarNameInTable="columnSalePrice" msprop:Generator_ColumnPropNameInRow="SalePrice" msprop:Generator_ColumnPropNameInTable="SalePriceColumn" msprop:Generator_UserColumnName="SalePrice" type="xs:decimal" minOccurs="0" />
              <xs:element name="Discontinued" msprop:Generator_ColumnVarNameInTable="columnDiscontinued" msprop:Generator_ColumnPropNameInRow="Discontinued" msprop:Generator_ColumnPropNameInTable="DiscontinuedColumn" msprop:Generator_UserColumnName="Discontinued" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblTransaction" msprop:Generator_TableClassName="tblTransactionDataTable" msprop:Generator_TableVarName="tabletblTransaction" msprop:Generator_TablePropName="tblTransaction" msprop:Generator_RowDeletingName="tblTransactionRowDeleting" msprop:Generator_UserTableName="tblTransaction" msprop:Generator_RowChangingName="tblTransactionRowChanging" msprop:Generator_RowEvHandlerName="tblTransactionRowChangeEventHandler" msprop:Generator_RowDeletedName="tblTransactionRowDeleted" msprop:Generator_RowEvArgName="tblTransactionRowChangeEvent" msprop:Generator_RowChangedName="tblTransactionRowChanged" msprop:Generator_RowClassName="tblTransactionRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TransactionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" msprop:Generator_UserColumnName="TransactionID" type="xs:int" />
              <xs:element name="TransactionDetails" msprop:Generator_ColumnVarNameInTable="columnTransactionDetails" msprop:Generator_ColumnPropNameInRow="TransactionDetails" msprop:Generator_ColumnPropNameInTable="TransactionDetailsColumn" msprop:Generator_UserColumnName="TransactionDetails">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionDate" msprop:Generator_ColumnVarNameInTable="columnTransactionDate" msprop:Generator_ColumnPropNameInRow="TransactionDate" msprop:Generator_ColumnPropNameInTable="TransactionDateColumn" msprop:Generator_UserColumnName="TransactionDate" type="xs:dateTime" />
              <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrderNo" msprop:Generator_ColumnVarNameInTable="columnOrderNo" msprop:Generator_ColumnPropNameInRow="OrderNo" msprop:Generator_ColumnPropNameInTable="OrderNoColumn" msprop:Generator_UserColumnName="OrderNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ClientID" msprop:Generator_ColumnVarNameInTable="columnClientID" msprop:Generator_ColumnPropNameInRow="ClientID" msprop:Generator_ColumnPropNameInTable="ClientIDColumn" msprop:Generator_UserColumnName="ClientID" type="xs:int" minOccurs="0" />
              <xs:element name="TransactionTypeID" msprop:Generator_ColumnVarNameInTable="columnTransactionTypeID" msprop:Generator_ColumnPropNameInRow="TransactionTypeID" msprop:Generator_ColumnPropNameInTable="TransactionTypeIDColumn" msprop:Generator_UserColumnName="TransactionTypeID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblWareHouse" msprop:Generator_TableClassName="tblWareHouseDataTable" msprop:Generator_TableVarName="tabletblWareHouse" msprop:Generator_TablePropName="tblWareHouse" msprop:Generator_RowDeletingName="tblWareHouseRowDeleting" msprop:Generator_UserTableName="tblWareHouse" msprop:Generator_RowChangingName="tblWareHouseRowChanging" msprop:Generator_RowEvHandlerName="tblWareHouseRowChangeEventHandler" msprop:Generator_RowDeletedName="tblWareHouseRowDeleted" msprop:Generator_RowEvArgName="tblWareHouseRowChangeEvent" msprop:Generator_RowChangedName="tblWareHouseRowChanged" msprop:Generator_RowClassName="tblWareHouseRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WareHouseID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnWareHouseID" msprop:Generator_ColumnPropNameInRow="WareHouseID" msprop:Generator_ColumnPropNameInTable="WareHouseIDColumn" msprop:Generator_UserColumnName="WareHouseID" type="xs:int" />
              <xs:element name="WareHouseName" msprop:Generator_ColumnVarNameInTable="columnWareHouseName" msprop:Generator_ColumnPropNameInRow="WareHouseName" msprop:Generator_ColumnPropNameInTable="WareHouseNameColumn" msprop:Generator_UserColumnName="WareHouseName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TelephoneNo" msprop:Generator_ColumnVarNameInTable="columnTelephoneNo" msprop:Generator_ColumnPropNameInRow="TelephoneNo" msprop:Generator_ColumnPropNameInTable="TelephoneNoColumn" msprop:Generator_UserColumnName="TelephoneNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="InventoryDetails" msprop:Generator_TableClassName="InventoryDetailsDataTable" msprop:Generator_TableVarName="tableInventoryDetails" msprop:Generator_TablePropName="InventoryDetails" msprop:Generator_RowDeletingName="InventoryDetailsRowDeleting" msprop:Generator_UserTableName="InventoryDetails" msprop:Generator_RowChangingName="InventoryDetailsRowChanging" msprop:Generator_RowEvHandlerName="InventoryDetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="InventoryDetailsRowDeleted" msprop:Generator_RowEvArgName="InventoryDetailsRowChangeEvent" msprop:Generator_RowChangedName="InventoryDetailsRowChanged" msprop:Generator_RowClassName="InventoryDetailsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ProductID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
              <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Manufacturer" msprop:Generator_ColumnVarNameInTable="columnManufacturer" msprop:Generator_ColumnPropNameInRow="Manufacturer" msprop:Generator_ColumnPropNameInTable="ManufacturerColumn" msprop:Generator_UserColumnName="Manufacturer" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WareHouseID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnWareHouseID" msprop:Generator_ColumnPropNameInRow="WareHouseID" msprop:Generator_ColumnPropNameInTable="WareHouseIDColumn" msprop:Generator_UserColumnName="WareHouseID" type="xs:int" />
              <xs:element name="WareHouseName" msprop:Generator_ColumnVarNameInTable="columnWareHouseName" msprop:Generator_ColumnPropNameInRow="WareHouseName" msprop:Generator_ColumnPropNameInTable="WareHouseNameColumn" msprop:Generator_UserColumnName="WareHouseName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cost" msprop:Generator_ColumnVarNameInTable="columnCost" msprop:Generator_ColumnPropNameInRow="Cost" msprop:Generator_ColumnPropNameInTable="CostColumn" msprop:Generator_UserColumnName="Cost" type="xs:decimal" />
              <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblTransactionType" msprop:Generator_TableClassName="tblTransactionTypeDataTable" msprop:Generator_TableVarName="tabletblTransactionType" msprop:Generator_TablePropName="tblTransactionType" msprop:Generator_RowDeletingName="tblTransactionTypeRowDeleting" msprop:Generator_UserTableName="tblTransactionType" msprop:Generator_RowChangingName="tblTransactionTypeRowChanging" msprop:Generator_RowEvHandlerName="tblTransactionTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="tblTransactionTypeRowDeleted" msprop:Generator_RowEvArgName="tblTransactionTypeRowChangeEvent" msprop:Generator_RowChangedName="tblTransactionTypeRowChanged" msprop:Generator_RowClassName="tblTransactionTypeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TransactionTypeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnTransactionTypeID" msprop:Generator_ColumnPropNameInRow="TransactionTypeID" msprop:Generator_ColumnPropNameInTable="TransactionTypeIDColumn" msprop:Generator_UserColumnName="TransactionTypeID" type="xs:int" />
              <xs:element name="TransactionType" msprop:Generator_ColumnVarNameInTable="columnTransactionType" msprop:Generator_ColumnPropNameInRow="TransactionType" msprop:Generator_ColumnPropNameInTable="TransactionTypeColumn" msprop:Generator_UserColumnName="TransactionType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActionType" msprop:Generator_ColumnVarNameInTable="columnActionType" msprop:Generator_ColumnPropNameInRow="ActionType" msprop:Generator_ColumnPropNameInTable="ActionTypeColumn" msprop:Generator_UserColumnName="ActionType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HasClientOrderInformation" msprop:Generator_ColumnVarNameInTable="columnHasClientOrderInformation" msprop:Generator_ColumnPropNameInRow="HasClientOrderInformation" msprop:Generator_ColumnPropNameInTable="HasClientOrderInformationColumn" msprop:Generator_UserColumnName="HasClientOrderInformation" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ClientTransactions" msprop:Generator_TableClassName="ClientTransactionsDataTable" msprop:Generator_TableVarName="tableClientTransactions" msprop:Generator_TablePropName="ClientTransactions" msprop:Generator_RowDeletingName="ClientTransactionsRowDeleting" msprop:Generator_UserTableName="ClientTransactions" msprop:Generator_RowChangingName="ClientTransactionsRowChanging" msprop:Generator_RowEvHandlerName="ClientTransactionsRowChangeEventHandler" msprop:Generator_RowDeletedName="ClientTransactionsRowDeleted" msprop:Generator_RowEvArgName="ClientTransactionsRowChangeEvent" msprop:Generator_RowChangedName="ClientTransactionsRowChanged" msprop:Generator_RowClassName="ClientTransactionsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TransactionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" msprop:Generator_UserColumnName="TransactionID" type="xs:int" />
              <xs:element name="TransactionDetails" msprop:Generator_ColumnVarNameInTable="columnTransactionDetails" msprop:Generator_ColumnPropNameInRow="TransactionDetails" msprop:Generator_ColumnPropNameInTable="TransactionDetailsColumn" msprop:Generator_UserColumnName="TransactionDetails">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransactionDate" msprop:Generator_ColumnVarNameInTable="columnTransactionDate" msprop:Generator_ColumnPropNameInRow="TransactionDate" msprop:Generator_ColumnPropNameInTable="TransactionDateColumn" msprop:Generator_UserColumnName="TransactionDate" type="xs:dateTime" />
              <xs:element name="TransactionTypeID" msprop:Generator_ColumnVarNameInTable="columnTransactionTypeID" msprop:Generator_ColumnPropNameInRow="TransactionTypeID" msprop:Generator_ColumnPropNameInTable="TransactionTypeIDColumn" msprop:Generator_UserColumnName="TransactionTypeID" type="xs:int" />
              <xs:element name="TransactionType" msprop:Generator_ColumnVarNameInTable="columnTransactionType" msprop:Generator_ColumnPropNameInRow="TransactionType" msprop:Generator_ColumnPropNameInTable="TransactionTypeColumn" msprop:Generator_UserColumnName="TransactionType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActionType" msprop:Generator_ColumnVarNameInTable="columnActionType" msprop:Generator_ColumnPropNameInRow="ActionType" msprop:Generator_ColumnPropNameInTable="ActionTypeColumn" msprop:Generator_UserColumnName="ActionType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HasClientOrderInformation" msprop:Generator_ColumnVarNameInTable="columnHasClientOrderInformation" msprop:Generator_ColumnPropNameInRow="HasClientOrderInformation" msprop:Generator_ColumnPropNameInTable="HasClientOrderInformationColumn" msprop:Generator_UserColumnName="HasClientOrderInformation" type="xs:boolean" />
              <xs:element name="Remarks" msprop:Generator_ColumnVarNameInTable="columnRemarks" msprop:Generator_ColumnPropNameInRow="Remarks" msprop:Generator_ColumnPropNameInTable="RemarksColumn" msprop:Generator_UserColumnName="Remarks" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrderNo" msprop:Generator_ColumnVarNameInTable="columnOrderNo" msprop:Generator_ColumnPropNameInRow="OrderNo" msprop:Generator_ColumnPropNameInTable="OrderNoColumn" msprop:Generator_UserColumnName="OrderNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ClientID" msprop:Generator_ColumnVarNameInTable="columnClientID" msprop:Generator_ColumnPropNameInRow="ClientID" msprop:Generator_ColumnPropNameInTable="ClientIDColumn" msprop:Generator_UserColumnName="ClientID" type="xs:int" minOccurs="0" />
              <xs:element name="ClientName" msprop:Generator_ColumnVarNameInTable="columnClientName" msprop:Generator_ColumnPropNameInRow="ClientName" msprop:Generator_ColumnPropNameInTable="ClientNameColumn" msprop:Generator_UserColumnName="ClientName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblTransactionDetails" msprop:Generator_TableClassName="tblTransactionDetailsDataTable" msprop:Generator_TableVarName="tabletblTransactionDetails" msprop:Generator_TablePropName="tblTransactionDetails" msprop:Generator_RowDeletingName="tblTransactionDetailsRowDeleting" msprop:Generator_UserTableName="tblTransactionDetails" msprop:Generator_RowChangingName="tblTransactionDetailsRowChanging" msprop:Generator_RowEvHandlerName="tblTransactionDetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="tblTransactionDetailsRowDeleted" msprop:Generator_RowEvArgName="tblTransactionDetailsRowChangeEvent" msprop:Generator_RowChangedName="tblTransactionDetailsRowChanged" msprop:Generator_RowClassName="tblTransactionDetailsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TransactionDetailID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnTransactionDetailID" msprop:Generator_ColumnPropNameInRow="TransactionDetailID" msprop:Generator_ColumnPropNameInTable="TransactionDetailIDColumn" msprop:Generator_UserColumnName="TransactionDetailID" type="xs:int" />
              <xs:element name="TransactionID" msprop:Generator_ColumnVarNameInTable="columnTransactionID" msprop:Generator_ColumnPropNameInRow="TransactionID" msprop:Generator_ColumnPropNameInTable="TransactionIDColumn" msprop:Generator_UserColumnName="TransactionID" type="xs:int" />
              <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
              <xs:element name="FromWareHouseID" msprop:Generator_ColumnVarNameInTable="columnFromWareHouseID" msprop:Generator_ColumnPropNameInRow="FromWareHouseID" msprop:Generator_ColumnPropNameInTable="FromWareHouseIDColumn" msprop:Generator_UserColumnName="FromWareHouseID" type="xs:int" />
              <xs:element name="ToWareHouseID" msprop:nullValue="_throw" msprop:Generator_ColumnPropNameInRow="ToWareHouseID" msprop:Generator_ColumnVarNameInTable="columnToWareHouseID" msprop:Generator_ColumnPropNameInTable="ToWareHouseIDColumn" msprop:Generator_UserColumnName="ToWareHouseID" type="xs:int" minOccurs="0" />
              <xs:element name="TransactQuantity" msprop:Generator_ColumnVarNameInTable="columnTransactQuantity" msprop:Generator_ColumnPropNameInRow="TransactQuantity" msprop:Generator_ColumnPropNameInTable="TransactQuantityColumn" msprop:Generator_UserColumnName="TransactQuantity" type="xs:decimal" />
              <xs:element name="TransactCost" msprop:Generator_ColumnVarNameInTable="columnTransactCost" msprop:Generator_ColumnPropNameInRow="TransactCost" msprop:Generator_ColumnPropNameInTable="TransactCostColumn" msprop:Generator_UserColumnName="TransactCost" type="xs:decimal" minOccurs="0" />
              <xs:element name="TotalCost" msprop:Generator_ColumnVarNameInTable="columnTotalCost" msprop:Generator_ColumnPropNameInRow="TotalCost" msprop:Generator_ColumnPropNameInTable="TotalCostColumn" msprop:Generator_UserColumnName="TotalCost" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblTransactionStockInformation" msprop:Generator_TableClassName="tblTransactionStockInformationDataTable" msprop:Generator_TableVarName="tabletblTransactionStockInformation" msprop:Generator_TablePropName="tblTransactionStockInformation" msprop:Generator_RowDeletingName="tblTransactionStockInformationRowDeleting" msprop:Generator_UserTableName="tblTransactionStockInformation" msprop:Generator_RowChangingName="tblTransactionStockInformationRowChanging" msprop:Generator_RowEvHandlerName="tblTransactionStockInformationRowChangeEventHandler" msprop:Generator_RowDeletedName="tblTransactionStockInformationRowDeleted" msprop:Generator_RowEvArgName="tblTransactionStockInformationRowChangeEvent" msprop:Generator_RowChangedName="tblTransactionStockInformationRowChanged" msprop:Generator_RowClassName="tblTransactionStockInformationRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TransactionStockInformationID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnTransactionStockInformationID" msprop:Generator_ColumnPropNameInRow="TransactionStockInformationID" msprop:Generator_ColumnPropNameInTable="TransactionStockInformationIDColumn" msprop:Generator_UserColumnName="TransactionStockInformationID" type="xs:int" />
              <xs:element name="TransactionDetailID" msprop:Generator_ColumnVarNameInTable="columnTransactionDetailID" msprop:Generator_ColumnPropNameInRow="TransactionDetailID" msprop:Generator_ColumnPropNameInTable="TransactionDetailIDColumn" msprop:Generator_UserColumnName="TransactionDetailID" type="xs:int" />
              <xs:element name="Cost" msprop:Generator_ColumnVarNameInTable="columnCost" msprop:Generator_ColumnPropNameInRow="Cost" msprop:Generator_ColumnPropNameInTable="CostColumn" msprop:Generator_UserColumnName="Cost" type="xs:decimal" />
              <xs:element name="OldQuantity" msprop:Generator_ColumnVarNameInTable="columnOldQuantity" msprop:Generator_ColumnPropNameInRow="OldQuantity" msprop:Generator_ColumnPropNameInTable="OldQuantityColumn" msprop:Generator_UserColumnName="OldQuantity" type="xs:decimal" />
              <xs:element name="NewQuantity" msprop:Generator_ColumnVarNameInTable="columnNewQuantity" msprop:Generator_ColumnPropNameInRow="NewQuantity" msprop:Generator_ColumnPropNameInTable="NewQuantityColumn" msprop:Generator_UserColumnName="NewQuantity" type="xs:decimal" />
              <xs:element name="IsFromWareHouse" msprop:Generator_ColumnVarNameInTable="columnIsFromWareHouse" msprop:Generator_ColumnPropNameInRow="IsFromWareHouse" msprop:Generator_ColumnPropNameInTable="IsFromWareHouseColumn" msprop:Generator_UserColumnName="IsFromWareHouse" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblClient" />
      <xs:field xpath="mstns:ClientID" />
    </xs:unique>
    <xs:unique name="tblInventory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblInventory" />
      <xs:field xpath="mstns:InventoryID" />
    </xs:unique>
    <xs:unique name="tblProducts_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblProducts" />
      <xs:field xpath="mstns:ProductID" />
    </xs:unique>
    <xs:unique name="tblTransaction_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblTransaction" />
      <xs:field xpath="mstns:TransactionID" />
    </xs:unique>
    <xs:unique name="tblWareHouse_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblWareHouse" />
      <xs:field xpath="mstns:WareHouseID" />
    </xs:unique>
    <xs:unique name="tblTransactionType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblTransactionType" />
      <xs:field xpath="mstns:TransactionTypeID" />
    </xs:unique>
    <xs:unique name="ClientTransactions_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ClientTransactions" />
      <xs:field xpath="mstns:TransactionID" />
    </xs:unique>
    <xs:unique name="tblTransactionDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblTransactionDetails" />
      <xs:field xpath="mstns:TransactionDetailID" />
    </xs:unique>
    <xs:unique name="tblTransactionStockInformation_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblTransactionStockInformation" />
      <xs:field xpath="mstns:TransactionStockInformationID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblInventory_tblProducts" msdata:parent="tblProducts" msdata:child="tblInventory" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="tblInventory" msprop:Generator_ChildPropName="GettblInventoryRows" msprop:Generator_ParentPropName="tblProductsRow" msprop:Generator_UserRelationName="FK_tblInventory_tblProducts" msprop:Generator_RelationVarName="relationFK_tblInventory_tblProducts" msprop:Generator_UserParentTable="tblProducts" />
      <msdata:Relationship name="FK_tblInventory_tblWareHouse" msdata:parent="tblWareHouse" msdata:child="tblInventory" msdata:parentkey="WareHouseID" msdata:childkey="WareHouseID" msprop:Generator_UserChildTable="tblInventory" msprop:Generator_ChildPropName="GettblInventoryRows" msprop:Generator_ParentPropName="tblWareHouseRow" msprop:Generator_UserRelationName="FK_tblInventory_tblWareHouse" msprop:Generator_RelationVarName="relationFK_tblInventory_tblWareHouse" msprop:Generator_UserParentTable="tblWareHouse" />
      <msdata:Relationship name="FK_tblTransaction_tblClient" msdata:parent="tblClient" msdata:child="tblTransaction" msdata:parentkey="ClientID" msdata:childkey="ClientID" msprop:Generator_UserChildTable="tblTransaction" msprop:Generator_ChildPropName="GettblTransactionRows" msprop:Generator_ParentPropName="tblClientRow" msprop:Generator_UserRelationName="FK_tblTransaction_tblClient" msprop:Generator_RelationVarName="relationFK_tblTransaction_tblClient" msprop:Generator_UserParentTable="tblClient" />
      <msdata:Relationship name="FK_InventoryDetails_tblProducts" msdata:parent="tblProducts" msdata:child="InventoryDetails" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="InventoryDetails" msprop:Generator_ChildPropName="GetInventoryDetailsRows" msprop:Generator_ParentPropName="tblProductsRow" msprop:Generator_UserRelationName="FK_InventoryDetails_tblProducts" msprop:Generator_RelationVarName="relationFK_InventoryDetails_tblProducts" msprop:Generator_UserParentTable="tblProducts" />
      <msdata:Relationship name="FK_InventoryDetails_tblWareHouse" msdata:parent="tblWareHouse" msdata:child="InventoryDetails" msdata:parentkey="WareHouseID" msdata:childkey="WareHouseID" msprop:Generator_UserChildTable="InventoryDetails" msprop:Generator_ChildPropName="GetInventoryDetailsRows" msprop:Generator_ParentPropName="tblWareHouseRow" msprop:Generator_UserRelationName="FK_InventoryDetails_tblWareHouse" msprop:Generator_RelationVarName="relationFK_InventoryDetails_tblWareHouse" msprop:Generator_UserParentTable="tblWareHouse" />
      <msdata:Relationship name="FK_tblTransaction_tblTransactionType" msdata:parent="tblTransactionType" msdata:child="tblTransaction" msdata:parentkey="TransactionTypeID" msdata:childkey="TransactionTypeID" msprop:Generator_UserChildTable="tblTransaction" msprop:Generator_ChildPropName="GettblTransactionRows" msprop:Generator_UserParentTable="tblTransactionType" msprop:Generator_UserRelationName="FK_tblTransaction_tblTransactionType" msprop:Generator_RelationVarName="relationFK_tblTransaction_tblTransactionType" msprop:Generator_ParentPropName="tblTransactionTypeRow" />
      <msdata:Relationship name="FK_tblClient_ClientTransactions" msdata:parent="tblClient" msdata:child="ClientTransactions" msdata:parentkey="ClientID" msdata:childkey="ClientID" msprop:Generator_UserChildTable="ClientTransactions" msprop:Generator_ChildPropName="GetClientTransactionsRows" msprop:Generator_UserParentTable="tblClient" msprop:Generator_UserRelationName="FK_tblClient_ClientTransactions" msprop:Generator_RelationVarName="relationFK_tblClient_ClientTransactions" msprop:Generator_ParentPropName="tblClientRow" />
      <msdata:Relationship name="FK_tblTransactionDetails_tblProducts" msdata:parent="tblProducts" msdata:child="tblTransactionDetails" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="tblTransactionDetails" msprop:Generator_ChildPropName="GettblTransactionDetailsRows" msprop:Generator_ParentPropName="tblProductsRow" msprop:Generator_UserRelationName="FK_tblTransactionDetails_tblProducts" msprop:Generator_RelationVarName="relationFK_tblTransactionDetails_tblProducts" msprop:Generator_UserParentTable="tblProducts" />
      <msdata:Relationship name="FK_tblTransactionDetails_tblTransaction" msdata:parent="tblTransaction" msdata:child="tblTransactionDetails" msdata:parentkey="TransactionID" msdata:childkey="TransactionID" msprop:Generator_UserChildTable="tblTransactionDetails" msprop:Generator_ChildPropName="GettblTransactionDetailsRows" msprop:Generator_ParentPropName="tblTransactionRow" msprop:Generator_UserRelationName="FK_tblTransactionDetails_tblTransaction" msprop:Generator_RelationVarName="relationFK_tblTransactionDetails_tblTransaction" msprop:Generator_UserParentTable="tblTransaction" />
      <msdata:Relationship name="FK_tblTransactionDetails_tblWareHouse" msdata:parent="tblWareHouse" msdata:child="tblTransactionDetails" msdata:parentkey="WareHouseID" msdata:childkey="FromWareHouseID" msprop:Generator_UserChildTable="tblTransactionDetails" msprop:Generator_ChildPropName="GettblTransactionDetailsRowsByFK_tblTransactionDetails_tblWareHouse" msprop:Generator_ParentPropName="tblWareHouseRowByFK_tblTransactionDetails_tblWareHouse" msprop:Generator_UserRelationName="FK_tblTransactionDetails_tblWareHouse" msprop:Generator_RelationVarName="relationFK_tblTransactionDetails_tblWareHouse" msprop:Generator_UserParentTable="tblWareHouse" />
      <msdata:Relationship name="FK_tblTransactionDetails_tblWareHouse1" msdata:parent="tblWareHouse" msdata:child="tblTransactionDetails" msdata:parentkey="WareHouseID" msdata:childkey="ToWareHouseID" msprop:Generator_UserChildTable="tblTransactionDetails" msprop:Generator_ChildPropName="GettblTransactionDetailsRowsByFK_tblTransactionDetails_tblWareHouse1" msprop:Generator_ParentPropName="tblWareHouseRowByFK_tblTransactionDetails_tblWareHouse1" msprop:Generator_UserRelationName="FK_tblTransactionDetails_tblWareHouse1" msprop:Generator_RelationVarName="relationFK_tblTransactionDetails_tblWareHouse1" msprop:Generator_UserParentTable="tblWareHouse" />
      <msdata:Relationship name="FK_tblTransactionStockInformation_tblTransactionDetails" msdata:parent="tblTransactionDetails" msdata:child="tblTransactionStockInformation" msdata:parentkey="TransactionDetailID" msdata:childkey="TransactionDetailID" msprop:Generator_UserChildTable="tblTransactionStockInformation" msprop:Generator_ChildPropName="GettblTransactionStockInformationRows" msprop:Generator_ParentPropName="tblTransactionDetailsRow" msprop:Generator_UserRelationName="FK_tblTransactionStockInformation_tblTransactionDetails" msprop:Generator_RelationVarName="relationFK_tblTransactionStockInformation_tblTransactionDetails" msprop:Generator_UserParentTable="tblTransactionDetails" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>